﻿CREATE TABLE [dbo].[datAddress] (
    [AddressID]        INT            IDENTITY (1, 1) NOT NULL,
    [Street]           NVARCHAR (100) NULL,
    [StreetAdditional] NVARCHAR (100) NULL,
    [ZipCodeID]        INT            NULL,
    [IsActive]         BIT            CONSTRAINT [DF_datAddress_IsActive] DEFAULT ((1)) NOT NULL,
    [OrgKey]           INT            NULL,
    CONSTRAINT [PK_datAddress] PRIMARY KEY CLUSTERED ([AddressID] ASC),
    CONSTRAINT [FK_datAddress_Postleitzahl] FOREIGN KEY ([ZipCodeID]) REFERENCES [dbo].[Postleitzahl] ([EPLZ])
);



